Skip to content

Latest commit

 

History

History
45 lines (39 loc) · 715 Bytes

File metadata and controls

45 lines (39 loc) · 715 Bytes

171. Excel Sheet Column Number

Given a column title as appear in an Excel sheet, return its corresponding column number.

For example:

 A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ... 

Example 1:

Input: "A" Output: 1 

Example 2:

Input: "AB" Output: 28 

Example 3:

Input: "ZY" Output: 701 

Solutions (Python)

1. Solution

classSolution: deftitleToNumber(self, s: str) ->int: ret=0forcins: ret*=26ret+=ord(c) -64returnret
close